Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 108014 |
| Missing cells | 650 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 19.0 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Text | 7 |
| Categorical | 3 |
| DateTime | 3 |
DEALKEY is highly overall correlated with DEALDETKEY | High correlation |
DEALDETKEY is highly overall correlated with DEALKEY | High correlation |
DEALVALUE is highly overall correlated with ORDER_PRICE and 2 other fields | High correlation |
ORDER_PRICE is highly overall correlated with DEALVALUE and 2 other fields | High correlation |
ORIGINAL_PRICE is highly overall correlated with DEALVALUE and 2 other fields | High correlation |
ORIGINAL_PRICE_NO_DISCOUNT_PERS is highly overall correlated with DEALVALUE and 2 other fields | High correlation |
CHANNELID is highly overall correlated with CHANNELDSC | High correlation |
CHANNELDSC is highly overall correlated with CHANNELID | High correlation |
DEALVALUE is highly skewed (γ1 = 328.585931) | Skewed |
DEALQTY is highly skewed (γ1 = 149.6666236) | Skewed |
ORDER_PRICE is highly skewed (γ1 = 116.3891148) | Skewed |
ORIGINAL_PRICE is highly skewed (γ1 = 116.1697965) | Skewed |
ORIGINAL_PRICE_NO_DISCOUNT_PERS is highly skewed (γ1 = 119.9378342) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
DEALDETKEY has unique values | Unique |
CUSTOMER_DISCOUNT_PERS has 84031 (77.8%) zeros | Zeros |
DISCOUNT_PCT has 48159 (44.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-09-25 08:53:47.748941 |
|---|---|
| Analysis finished | 2023-09-25 08:54:01.364039 |
| Duration | 13.62 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 108014 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54006.5 |
| Minimum | 0 |
|---|---|
| Maximum | 108013 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5400.65 |
| Q1 | 27003.25 |
| median | 54006.5 |
| Q3 | 81009.75 |
| 95-th percentile | 102612.35 |
| Maximum | 108013 |
| Range | 108013 |
| Interquartile range (IQR) | 54006.5 |
Descriptive statistics
| Standard deviation | 31181.1 |
|---|---|
| Coefficient of variation (CV) | 0.57735829 |
| Kurtosis | -1.2 |
| Mean | 54006.5 |
| Median Absolute Deviation (MAD) | 27003.5 |
| Skewness | 0 |
| Sum | 5.8334581 × 109 |
| Variance | 9.7226102 × 108 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 71992 | 1 | < 0.1% |
| 72016 | 1 | < 0.1% |
| 72015 | 1 | < 0.1% |
| 72014 | 1 | < 0.1% |
| 72013 | 1 | < 0.1% |
| 72012 | 1 | < 0.1% |
| 72011 | 1 | < 0.1% |
| 72010 | 1 | < 0.1% |
| 72009 | 1 | < 0.1% |
| Other values (108004) | 108004 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 108013 | 1 | |
| 108012 | 1 | |
| 108011 | 1 | |
| 108010 | 1 | |
| 108009 | 1 | |
| 108008 | 1 | |
| 108007 | 1 | |
| 108006 | 1 | |
| 108005 | 1 | |
| 108004 | 1 |
DEALKEY
Real number (ℝ)
HIGH CORRELATION
| Distinct | 46464 |
|---|---|
| Distinct (%) | 43.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3691601.1 |
| Minimum | 3639796 |
|---|---|
| Maximum | 3743622 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 3639796 |
|---|---|
| 5-th percentile | 3644567 |
| Q1 | 3665658.2 |
| median | 3691903 |
| Q3 | 3717626 |
| 95-th percentile | 3737135 |
| Maximum | 3743622 |
| Range | 103826 |
| Interquartile range (IQR) | 51967.75 |
Descriptive statistics
| Standard deviation | 29850.113 |
|---|---|
| Coefficient of variation (CV) | 0.0080859531 |
| Kurtosis | -1.210069 |
| Mean | 3691601.1 |
| Median Absolute Deviation (MAD) | 25996 |
| Skewness | -0.031073182 |
| Sum | 3.987446 × 1011 |
| Variance | 8.9102927 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3734160 | 191 | 0.2% |
| 3735316 | 164 | 0.2% |
| 3716278 | 162 | 0.1% |
| 3708521 | 160 | 0.1% |
| 3696477 | 149 | 0.1% |
| 3741258 | 148 | 0.1% |
| 3708646 | 143 | 0.1% |
| 3702275 | 129 | 0.1% |
| 3708519 | 123 | 0.1% |
| 3710995 | 115 | 0.1% |
| Other values (46454) | 106530 |
| Value | Count | Frequency (%) |
| 3639796 | 1 | |
| 3639798 | 2 | |
| 3639799 | 1 | |
| 3639800 | 2 | |
| 3639801 | 1 | |
| 3639802 | 1 | |
| 3639803 | 1 | |
| 3639806 | 2 | |
| 3639807 | 2 | |
| 3639808 | 1 |
| Value | Count | Frequency (%) |
| 3743622 | 1 | < 0.1% |
| 3743621 | 1 | < 0.1% |
| 3743618 | 1 | < 0.1% |
| 3743615 | 1 | < 0.1% |
| 3743613 | 1 | < 0.1% |
| 3743611 | 3 | |
| 3743610 | 1 | < 0.1% |
| 3743607 | 1 | < 0.1% |
| 3743598 | 1 | < 0.1% |
| 3743597 | 1 | < 0.1% |
DEALDETKEY
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 108014 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12111106 |
| Minimum | 11986442 |
|---|---|
| Maximum | 12238490 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 11986442 |
|---|---|
| 5-th percentile | 11998538 |
| Q1 | 12049075 |
| median | 12111432 |
| Q3 | 12173418 |
| 95-th percentile | 12221243 |
| Maximum | 12238490 |
| Range | 252048 |
| Interquartile range (IQR) | 124343.25 |
Descriptive statistics
| Standard deviation | 71712.392 |
|---|---|
| Coefficient of variation (CV) | 0.005921209 |
| Kurtosis | -1.197274 |
| Mean | 12111106 |
| Median Absolute Deviation (MAD) | 62173.5 |
| Skewness | -0.016600549 |
| Sum | 1.3081691 × 1012 |
| Variance | 5.1426672 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12089692 | 1 | < 0.1% |
| 12189573 | 1 | < 0.1% |
| 12078727 | 1 | < 0.1% |
| 11993357 | 1 | < 0.1% |
| 12138390 | 1 | < 0.1% |
| 12029379 | 1 | < 0.1% |
| 12004464 | 1 | < 0.1% |
| 12032124 | 1 | < 0.1% |
| 12221414 | 1 | < 0.1% |
| 12219510 | 1 | < 0.1% |
| Other values (108004) | 108004 |
| Value | Count | Frequency (%) |
| 11986442 | 1 | |
| 11986445 | 1 | |
| 11986446 | 1 | |
| 11986448 | 1 | |
| 11986449 | 1 | |
| 11986450 | 1 | |
| 11986452 | 1 | |
| 11986456 | 1 | |
| 11986457 | 1 | |
| 11986460 | 1 |
| Value | Count | Frequency (%) |
| 12238490 | 1 | |
| 12238489 | 1 | |
| 12238481 | 1 | |
| 12238475 | 1 | |
| 12238472 | 1 | |
| 12238470 | 1 | |
| 12238469 | 1 | |
| 12238468 | 1 | |
| 12238467 | 1 | |
| 12238404 | 1 |
CUSTOMERID
Text
| Distinct | 5666 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1080140 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1158 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | 053e113f9b |
|---|---|
| 2nd row | b6fc01a771 |
| 3rd row | 9b2a287a25 |
| 4th row | 64354f1917 |
| 5th row | df63f09ef0 |
| Value | Count | Frequency (%) |
| 216e149e5b | 1315 | 1.2% |
| 1972a513cf | 863 | 0.8% |
| 3142781c56 | 566 | 0.5% |
| 2ab0d23c98 | 542 | 0.5% |
| 2eab4308e0 | 538 | 0.5% |
| b8320bfadc | 532 | 0.5% |
| 48c887035b | 527 | 0.5% |
| 7ee47b2b4b | 521 | 0.5% |
| ea9ce80d4b | 492 | 0.5% |
| 19323567eb | 462 | 0.4% |
| Other values (5656) | 101656 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 71414 | 6.6% |
| 3 | 70942 | 6.6% |
| 2 | 70617 | 6.5% |
| b | 70035 | 6.5% |
| 4 | 69914 | 6.5% |
| 1 | 69456 | 6.4% |
| c | 67961 | 6.3% |
| f | 67931 | 6.3% |
| a | 67377 | 6.2% |
| 5 | 66632 | 6.2% |
| Other values (6) | 387861 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 671196 | |
| Lowercase Letter | 408944 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 70942 | |
| 2 | 70617 | |
| 4 | 69914 | |
| 1 | 69456 | |
| 5 | 66632 | |
| 7 | 66066 | |
| 9 | 65844 | |
| 8 | 65794 | |
| 0 | 64348 | |
| 6 | 61583 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 71414 | |
| b | 70035 | |
| c | 67961 | |
| f | 67931 | |
| a | 67377 | |
| d | 64226 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 671196 | |
| Latin | 408944 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 70942 | |
| 2 | 70617 | |
| 4 | 69914 | |
| 1 | 69456 | |
| 5 | 66632 | |
| 7 | 66066 | |
| 9 | 65844 | |
| 8 | 65794 | |
| 0 | 64348 | |
| 6 | 61583 |
Latin
| Value | Count | Frequency (%) |
| e | 71414 | |
| b | 70035 | |
| c | 67961 | |
| f | 67931 | |
| a | 67377 | |
| d | 64226 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1080140 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 71414 | 6.6% |
| 3 | 70942 | 6.6% |
| 2 | 70617 | 6.5% |
| b | 70035 | 6.5% |
| 4 | 69914 | 6.5% |
| 1 | 69456 | 6.4% |
| c | 67961 | 6.3% |
| f | 67931 | 6.3% |
| a | 67377 | 6.2% |
| 5 | 66632 | 6.2% |
| Other values (6) | 387861 |
CHANNELID
Categorical
HIGH CORRELATION
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
| CS | |
|---|---|
| SM | |
| VN | |
| CC | |
| VS | |
| Other values (20) |
Length
| Max length | 6 |
|---|---|
| Median length | 2 |
| Mean length | 2.024071 |
| Min length | 2 |
Characters and Unicode
| Total characters | 218628 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SM |
|---|---|
| 2nd row | CS |
| 3rd row | SM |
| 4th row | CS |
| 5th row | SM |
Common Values
| Value | Count | Frequency (%) |
| CS | 37780 | |
| SM | 32704 | |
| VN | 8644 | 8.0% |
| CC | 8392 | 7.8% |
| VS | 6959 | 6.4% |
| TE | 3320 | 3.1% |
| FU | 2018 | 1.9% |
| AN | 1782 | 1.6% |
| VE | 1534 | 1.4% |
| VO | 1063 | 1.0% |
| Other values (15) | 3818 | 3.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| cs | 37780 | |
| sm | 32704 | |
| vn | 8644 | 8.0% |
| cc | 8392 | 7.8% |
| vs | 6959 | 6.4% |
| te | 3320 | 3.1% |
| fu | 2018 | 1.9% |
| an | 1782 | 1.6% |
| ve | 1534 | 1.4% |
| vo | 1063 | 1.0% |
| Other values (15) | 3818 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 78833 | |
| C | 54832 | |
| M | 32705 | |
| V | 18326 | 8.4% |
| N | 10428 | 4.8% |
| E | 4854 | 2.2% |
| T | 3442 | 1.6% |
| A | 3028 | 1.4% |
| F | 2019 | 0.9% |
| U | 2018 | 0.9% |
| Other values (11) | 8143 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 214728 | |
| Lowercase Letter | 2600 | 1.2% |
| Open Punctuation | 650 | 0.3% |
| Close Punctuation | 650 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 78833 | |
| C | 54832 | |
| M | 32705 | |
| V | 18326 | 8.5% |
| N | 10428 | 4.9% |
| E | 4854 | 2.3% |
| T | 3442 | 1.6% |
| A | 3028 | 1.4% |
| F | 2019 | 0.9% |
| U | 2018 | 0.9% |
| Other values (6) | 4243 | 2.0% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 1300 | |
| n | 650 | |
| u | 650 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 650 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 650 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 217328 | |
| Common | 1300 | 0.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 78833 | |
| C | 54832 | |
| M | 32705 | |
| V | 18326 | 8.4% |
| N | 10428 | 4.8% |
| E | 4854 | 2.2% |
| T | 3442 | 1.6% |
| A | 3028 | 1.4% |
| F | 2019 | 0.9% |
| U | 2018 | 0.9% |
| Other values (9) | 6843 | 3.1% |
Common
| Value | Count | Frequency (%) |
| ( | 650 | |
| ) | 650 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 218628 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 78833 | |
| C | 54832 | |
| M | 32705 | |
| V | 18326 | 8.4% |
| N | 10428 | 4.8% |
| E | 4854 | 2.2% |
| T | 3442 | 1.6% |
| A | 3028 | 1.4% |
| F | 2019 | 0.9% |
| U | 2018 | 0.9% |
| Other values (11) | 8143 | 3.7% |
CHANNELDSC
Categorical
HIGH CORRELATION
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 650 |
| Missing (%) | 0.6% |
| Memory size | 844.0 KiB |
| OFFICE PRODUCTS SALES AREA | |
|---|---|
| SALES UNIT MEDIUM BUSINESS | |
| CORPORATE NORD | |
| CONTACT CENTER | |
| CORPORATE CENTRO SUD | |
| Other values (19) |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 23.258215 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2497095 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SALES UNIT MEDIUM BUSINESS |
|---|---|
| 2nd row | OFFICE PRODUCTS SALES AREA |
| 3rd row | SALES UNIT MEDIUM BUSINESS |
| 4th row | OFFICE PRODUCTS SALES AREA |
| 5th row | SALES UNIT MEDIUM BUSINESS |
Common Values
| Value | Count | Frequency (%) |
| OFFICE PRODUCTS SALES AREA | 37780 | |
| SALES UNIT MEDIUM BUSINESS | 32704 | |
| CORPORATE NORD | 8644 | 8.0% |
| CONTACT CENTER | 8392 | 7.8% |
| CORPORATE CENTRO SUD | 6959 | 6.4% |
| TELEFONIA (MOBILE PHONE CHANNE | 3320 | 3.1% |
| FURNITURE (FURNITURE CHANNEL D | 2018 | 1.9% |
| ASSOTEAM NORD | 1782 | 1.6% |
| VENDORS PARTNERS DIPENDENTI | 1534 | 1.4% |
| SHOP ON LINE | 1063 | 1.0% |
| Other values (14) | 3168 | 2.9% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| sales | 70484 | |
| office | 37780 | |
| area | 37780 | |
| products | 37780 | |
| unit | 32704 | |
| medium | 32704 | |
| business | 32704 | |
| corporate | 15603 | 4.1% |
| nord | 10426 | 2.8% |
| contact | 8392 | 2.2% |
| Other values (42) | 61956 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 296705 | |
| E | 286108 | |
| 270951 | ||
| A | 187192 | 7.5% |
| I | 153529 | 6.1% |
| U | 153069 | 6.1% |
| O | 151436 | 6.1% |
| R | 146877 | 5.9% |
| T | 132879 | 5.3% |
| N | 131496 | 5.3% |
| Other values (19) | 586853 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2219063 | |
| Space Separator | 270951 | 10.9% |
| Open Punctuation | 5340 | 0.2% |
| Other Punctuation | 1013 | < 0.1% |
| Dash Punctuation | 726 | < 0.1% |
| Close Punctuation | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 296705 | |
| E | 286108 | |
| A | 187192 | |
| I | 153529 | 6.9% |
| U | 153069 | 6.9% |
| O | 151436 | 6.8% |
| R | 146877 | 6.6% |
| T | 132879 | 6.0% |
| N | 131496 | 5.9% |
| C | 130318 | 5.9% |
| Other values (13) | 449454 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 891 | |
| & | 122 | 12.0% |
Space Separator
| Value | Count | Frequency (%) |
| 270951 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 5340 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 726 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2219063 | |
| Common | 278032 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 296705 | |
| E | 286108 | |
| A | 187192 | |
| I | 153529 | 6.9% |
| U | 153069 | 6.9% |
| O | 151436 | 6.8% |
| R | 146877 | 6.6% |
| T | 132879 | 6.0% |
| N | 131496 | 5.9% |
| C | 130318 | 5.9% |
| Other values (13) | 449454 |
Common
| Value | Count | Frequency (%) |
| 270951 | ||
| ( | 5340 | 1.9% |
| / | 891 | 0.3% |
| - | 726 | 0.3% |
| & | 122 | < 0.1% |
| ) | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2497095 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 296705 | |
| E | 286108 | |
| 270951 | ||
| A | 187192 | 7.5% |
| I | 153529 | 6.1% |
| U | 153069 | 6.1% |
| O | 151436 | 6.1% |
| R | 146877 | 5.9% |
| T | 132879 | 5.3% |
| N | 131496 | 5.3% |
| Other values (19) | 586853 |
HAS_REAL_ORDER
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 108014 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 66888 | |
| 0 | 41126 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 66888 | |
| 0 | 41126 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 66888 | |
| 0 | 41126 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 108014 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 66888 | |
| 0 | 41126 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 108014 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 66888 | |
| 0 | 41126 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 108014 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 66888 | |
| 0 | 41126 |
DEALVALUE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 68217 |
|---|---|
| Distinct (%) | 63.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4457.0509 |
| Minimum | 0 |
|---|---|
| Maximum | 3.1816154 × 108 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6.473842 |
| Q1 | 41.980292 |
| median | 199 |
| Q3 | 785.97222 |
| 95-th percentile | 5099.805 |
| Maximum | 3.1816154 × 108 |
| Range | 3.1816154 × 108 |
| Interquartile range (IQR) | 743.99193 |
Descriptive statistics
| Standard deviation | 968135.19 |
|---|---|
| Coefficient of variation (CV) | 217.2143 |
| Kurtosis | 107983.74 |
| Mean | 4457.0509 |
| Median Absolute Deviation (MAD) | 185.56 |
| Skewness | 328.58593 |
| Sum | 4.8142389 × 108 |
| Variance | 9.3728575 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 199 | 193 | 0.2% |
| 189 | 149 | 0.1% |
| 365 | 74 | 0.1% |
| 0.01 | 71 | 0.1% |
| 39 | 69 | 0.1% |
| 4984.14 | 64 | 0.1% |
| 3332.22 | 64 | 0.1% |
| 6153.72 | 64 | 0.1% |
| 999 | 55 | 0.1% |
| 5381.05 | 51 | < 0.1% |
| Other values (68207) | 107160 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 0.01 | 71 | |
| 0.01823709 | 2 | < 0.1% |
| 0.02 | 2 | < 0.1% |
| 0.029022 | 1 | < 0.1% |
| 0.03 | 9 | < 0.1% |
| 0.05 | 3 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 13 | < 0.1% |
| 0.12 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 318161535 | 1 | |
| 2243150 | 1 | |
| 952664 | 1 | |
| 897260 | 1 | |
| 825902 | 1 | |
| 816488.75 | 1 | |
| 730764.72 | 1 | |
| 429086 | 1 | |
| 411757.5 | 1 | |
| 379533 | 1 |
DEALQTY
Real number (ℝ)
SKEWED
| Distinct | 412 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.351371 |
| Minimum | 0 |
|---|---|
| Maximum | 180000 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 40 |
| Maximum | 180000 |
| Range | 180000 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 745.41137 |
|---|---|
| Coefficient of variation (CV) | 29.403197 |
| Kurtosis | 32504.611 |
| Mean | 25.351371 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 149.66662 |
| Sum | 2738303 |
| Variance | 555638.11 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 51988 | |
| 2 | 15781 | 14.6% |
| 3 | 6723 | 6.2% |
| 5 | 5130 | 4.7% |
| 4 | 4704 | 4.4% |
| 10 | 4548 | 4.2% |
| 6 | 2208 | 2.0% |
| 20 | 1927 | 1.8% |
| 8 | 1170 | 1.1% |
| 30 | 1149 | 1.1% |
| Other values (402) | 12686 | 11.7% |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 1 | 51988 | |
| 2 | 15781 | 14.6% |
| 3 | 6723 | 6.2% |
| 4 | 4704 | 4.4% |
| 5 | 5130 | 4.7% |
| 6 | 2208 | 2.0% |
| 7 | 847 | 0.8% |
| 8 | 1170 | 1.1% |
| 9 | 542 | 0.5% |
| Value | Count | Frequency (%) |
| 180000 | 1 | < 0.1% |
| 57600 | 2 | < 0.1% |
| 36000 | 3 | < 0.1% |
| 28800 | 3 | < 0.1% |
| 24000 | 1 | < 0.1% |
| 22800 | 16 | |
| 21600 | 1 | < 0.1% |
| 19200 | 4 | < 0.1% |
| 18000 | 1 | < 0.1% |
| 15000 | 1 | < 0.1% |
ORDER_PRICE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 53681 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 355.07135 |
| Minimum | 0.009674 |
|---|---|
| Maximum | 424215.38 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 0.009674 |
|---|---|
| 5-th percentile | 2.44 |
| Q1 | 15.04 |
| median | 84.222825 |
| Q3 | 346 |
| 95-th percentile | 1399 |
| Maximum | 424215.38 |
| Range | 424215.37 |
| Interquartile range (IQR) | 330.96 |
Descriptive statistics
| Standard deviation | 2122.6674 |
|---|---|
| Coefficient of variation (CV) | 5.9781433 |
| Kurtosis | 18961.034 |
| Mean | 355.07135 |
| Median Absolute Deviation (MAD) | 78.108042 |
| Skewness | 116.38911 |
| Sum | 38352677 |
| Variance | 4505717 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 199 | 236 | 0.2% |
| 189 | 163 | 0.2% |
| 1538.43 | 124 | 0.1% |
| 1076.21 | 110 | 0.1% |
| 0.01 | 110 | 0.1% |
| 699 | 94 | 0.1% |
| 459 | 93 | 0.1% |
| 499 | 92 | 0.1% |
| 1661.38 | 91 | 0.1% |
| 1477.59 | 89 | 0.1% |
| Other values (53671) | 106812 |
| Value | Count | Frequency (%) |
| 0.009674 | 1 | < 0.1% |
| 0.01 | 110 | |
| 0.01823709 | 2 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.03 | 7 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | < 0.1% |
| 0.10549 | 2 | < 0.1% |
| 0.105754 | 1 | < 0.1% |
| 0.10582 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 424215.38 | 1 | |
| 247000 | 1 | |
| 221000 | 1 | |
| 215946 | 1 | |
| 175181.5 | 1 | |
| 71961.27 | 2 | |
| 67043.4 | 1 | |
| 60669 | 1 | |
| 59619.73 | 1 | |
| 54313.2 | 1 |
ORIGINAL_PRICE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 19216 |
|---|---|
| Distinct (%) | 17.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 358.46243 |
| Minimum | 0.01 |
|---|---|
| Maximum | 424215.38 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 2.49 |
| Q1 | 15.525 |
| median | 85 |
| Q3 | 351.185 |
| 95-th percentile | 1401 |
| Maximum | 424215.38 |
| Range | 424215.37 |
| Interquartile range (IQR) | 335.66 |
Descriptive statistics
| Standard deviation | 2123.9905 |
|---|---|
| Coefficient of variation (CV) | 5.9252807 |
| Kurtosis | 18913.092 |
| Mean | 358.46243 |
| Median Absolute Deviation (MAD) | 78.79 |
| Skewness | 116.1698 |
| Sum | 38718961 |
| Variance | 4511335.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 199 | 287 | 0.3% |
| 189 | 232 | 0.2% |
| 6.21 | 214 | 0.2% |
| 699 | 208 | 0.2% |
| 459 | 201 | 0.2% |
| 499 | 196 | 0.2% |
| 7.32 | 181 | 0.2% |
| 11.86 | 180 | 0.2% |
| 799 | 179 | 0.2% |
| 899 | 168 | 0.2% |
| Other values (19206) | 105968 |
| Value | Count | Frequency (%) |
| 0.01 | 111 | |
| 0.02 | 1 | < 0.1% |
| 0.03 | 9 | < 0.1% |
| 0.1 | 4 | < 0.1% |
| 0.11 | 16 | < 0.1% |
| 0.12 | 2 | < 0.1% |
| 0.16 | 2 | < 0.1% |
| 0.17 | 7 | < 0.1% |
| 0.18 | 2 | < 0.1% |
| 0.19 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 424215.38 | 1 | |
| 247000 | 1 | |
| 221000 | 1 | |
| 215946 | 1 | |
| 175181.5 | 1 | |
| 71961.27 | 2 | |
| 67043.4 | 1 | |
| 60669 | 1 | |
| 59619.73 | 1 | |
| 54313.2 | 1 |
ORIGINAL_PRICE_NO_DISCOUNT_PERS
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 26617 |
|---|---|
| Distinct (%) | 24.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 361.17283 |
| Minimum | 0.01 |
|---|---|
| Maximum | 445426.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 2.6565 |
| Q1 | 15.939 |
| median | 85.965 |
| Q3 | 352.9074 |
| 95-th percentile | 1419.831 |
| Maximum | 445426.15 |
| Range | 445426.14 |
| Interquartile range (IQR) | 336.9684 |
Descriptive statistics
| Standard deviation | 2212.0704 |
|---|---|
| Coefficient of variation (CV) | 6.1246867 |
| Kurtosis | 19763.657 |
| Mean | 361.17283 |
| Median Absolute Deviation (MAD) | 79.3826 |
| Skewness | 119.93783 |
| Sum | 39011722 |
| Variance | 4893255.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 199 | 265 | 0.2% |
| 189 | 210 | 0.2% |
| 699 | 206 | 0.2% |
| 459 | 201 | 0.2% |
| 499 | 196 | 0.2% |
| 799 | 179 | 0.2% |
| 11.86 | 178 | 0.2% |
| 899 | 168 | 0.2% |
| 999 | 166 | 0.2% |
| 469 | 157 | 0.1% |
| Other values (26607) | 106088 |
| Value | Count | Frequency (%) |
| 0.01 | 111 | |
| 0.02 | 1 | < 0.1% |
| 0.03 | 6 | < 0.1% |
| 0.0312 | 1 | < 0.1% |
| 0.037257 | 2 | < 0.1% |
| 0.1 | 4 | < 0.1% |
| 0.11 | 11 | < 0.1% |
| 0.12 | 2 | < 0.1% |
| 0.1232 | 5 | < 0.1% |
| 0.16 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 445426.149 | 1 | |
| 259350 | 1 | |
| 254150 | 1 | |
| 215946 | 1 | |
| 175181.5 | 1 | |
| 71961.27 | 2 | |
| 67043.4 | 1 | |
| 60669 | 1 | |
| 59619.73 | 1 | |
| 54313.2 | 1 |
QUOTATION_DATE
Date
| Distinct | 181 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
| Minimum | 2023-03-02 00:00:00 |
|---|---|
| Maximum | 2023-08-29 00:00:00 |
Histogram with fixed size bins (bins=50)
CUSTOMER_DISCOUNT_PERS
Real number (ℝ)
ZEROS
| Distinct | 189 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0418276 |
| Minimum | -20 |
|---|---|
| Maximum | 64.1 |
| Zeros | 84031 |
| Zeros (%) | 77.8% |
| Negative | 12 |
| Negative (%) | < 0.1% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | -20 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 15 |
| Maximum | 64.1 |
| Range | 84.1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.0167792 |
|---|---|
| Coefficient of variation (CV) | 2.4570043 |
| Kurtosis | 7.0380199 |
| Mean | 2.0418276 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.6913991 |
| Sum | 220545.97 |
| Variance | 25.168074 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 84031 | |
| 15 | 2802 | 2.6% |
| 20 | 1978 | 1.8% |
| 1 | 1341 | 1.2% |
| 2 | 1179 | 1.1% |
| 8 | 1168 | 1.1% |
| 10 | 1080 | 1.0% |
| 18 | 1059 | 1.0% |
| 3 | 987 | 0.9% |
| 4 | 939 | 0.9% |
| Other values (179) | 11450 | 10.6% |
| Value | Count | Frequency (%) |
| -20 | 1 | < 0.1% |
| -18 | 1 | < 0.1% |
| -10 | 2 | < 0.1% |
| -2.5 | 3 | < 0.1% |
| -2 | 1 | < 0.1% |
| -1.5 | 2 | < 0.1% |
| -1 | 2 | < 0.1% |
| 0 | 84031 | |
| 0.01 | 1 | < 0.1% |
| 0.03 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 64.1 | 5 | < 0.1% |
| 46.31 | 2 | < 0.1% |
| 38.9 | 1 | < 0.1% |
| 32 | 10 | < 0.1% |
| 30.65 | 6 | < 0.1% |
| 30 | 61 | |
| 28.72 | 2 | < 0.1% |
| 27.42 | 6 | < 0.1% |
| 26.25 | 2 | < 0.1% |
| 26 | 6 | < 0.1% |
DISCOUNT_PCT
Real number (ℝ)
ZEROS
| Distinct | 6022 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6882688 |
| Minimum | 0 |
|---|---|
| Maximum | 40 |
| Zeros | 48159 |
| Zeros (%) | 44.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 844.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.88 |
| Q3 | 2 |
| 95-th percentile | 6.0606 |
| Maximum | 40 |
| Range | 40 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.5294701 |
|---|---|
| Coefficient of variation (CV) | 2.0905854 |
| Kurtosis | 36.722569 |
| Mean | 1.6882688 |
| Median Absolute Deviation (MAD) | 0.88 |
| Skewness | 5.304876 |
| Sum | 182356.67 |
| Variance | 12.457159 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 48159 | |
| 2 | 8589 | 8.0% |
| 1 | 6660 | 6.2% |
| 3 | 2986 | 2.8% |
| 0.5 | 1753 | 1.6% |
| 1.5 | 1653 | 1.5% |
| 2.5 | 994 | 0.9% |
| 4 | 869 | 0.8% |
| 5 | 856 | 0.8% |
| 0.2 | 534 | 0.5% |
| Other values (6012) | 34961 |
| Value | Count | Frequency (%) |
| 0 | 48159 | |
| 0.002 | 1 | < 0.1% |
| 0.0039 | 1 | < 0.1% |
| 0.0093 | 1 | < 0.1% |
| 0.0095 | 1 | < 0.1% |
| 0.0115 | 1 | < 0.1% |
| 0.0133 | 1 | < 0.1% |
| 0.015 | 2 | < 0.1% |
| 0.0179 | 2 | < 0.1% |
| 0.018 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40 | 10 | |
| 39.7906 | 1 | < 0.1% |
| 39.6221 | 1 | < 0.1% |
| 39.5 | 1 | < 0.1% |
| 39.2097 | 2 | < 0.1% |
| 39.2062 | 1 | < 0.1% |
| 39.0031 | 2 | < 0.1% |
| 38.9978 | 1 | < 0.1% |
| 38.989 | 3 | < 0.1% |
| 38.9842 | 1 | < 0.1% |
| Distinct | 2921 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
| Minimum | 2000-01-01 00:00:00 |
|---|---|
| Maximum | 2023-08-28 00:00:00 |
Histogram with fixed size bins (bins=50)
ARTID
Text
| Distinct | 27419 |
|---|---|
| Distinct (%) | 25.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 12 |
| Mean length | 9.0203029 |
| Min length | 2 |
Characters and Unicode
| Total characters | 974319 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 11470 ? |
|---|---|
| Unique (%) | 10.6% |
Sample
| 1st row | FI-65F |
|---|---|
| 2nd row | KCN-00032 |
| 3rd row | CE313A |
| 4th row | NX090202106 |
| 5th row | 9155101C |
| Value | Count | Frequency (%) |
| t5d-03485 | 383 | 0.4% |
| mpww3ql/a | 171 | 0.2% |
| n16h6 | 151 | 0.1% |
| mfcl2710dw | 145 | 0.1% |
| 634-bykr | 140 | 0.1% |
| dell-wd19s130w | 106 | 0.1% |
| 9424697 | 106 | 0.1% |
| 865414-b21 | 106 | 0.1% |
| ac140401 | 105 | 0.1% |
| p46171-a21 | 105 | 0.1% |
| Other values (27407) | 106496 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 125986 | 12.9% |
| 1 | 79593 | 8.2% |
| 2 | 65577 | 6.7% |
| 3 | 50016 | 5.1% |
| 4 | 43995 | 4.5% |
| 5 | 41613 | 4.3% |
| A | 36755 | 3.8% |
| - | 36726 | 3.8% |
| 6 | 36188 | 3.7% |
| 7 | 30859 | 3.2% |
| Other values (32) | 427011 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 532163 | |
| Uppercase Letter | 395568 | |
| Dash Punctuation | 36726 | 3.8% |
| Other Punctuation | 8237 | 0.8% |
| Connector Punctuation | 1613 | 0.2% |
| Open Punctuation | 6 | < 0.1% |
| Close Punctuation | 6 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 36755 | 9.3% |
| E | 29796 | 7.5% |
| C | 24609 | 6.2% |
| S | 24225 | 6.1% |
| T | 23328 | 5.9% |
| B | 23205 | 5.9% |
| P | 19958 | 5.0% |
| L | 19002 | 4.8% |
| D | 17854 | 4.5% |
| M | 17305 | 4.4% |
| Other values (16) | 159531 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 125986 | |
| 1 | 79593 | |
| 2 | 65577 | |
| 3 | 50016 | 9.4% |
| 4 | 43995 | 8.3% |
| 5 | 41613 | 7.8% |
| 6 | 36188 | 6.8% |
| 7 | 30859 | 5.8% |
| 8 | 29412 | 5.5% |
| 9 | 28924 | 5.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 4810 | |
| . | 3427 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 36726 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1613 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 578751 | |
| Latin | 395568 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 36755 | 9.3% |
| E | 29796 | 7.5% |
| C | 24609 | 6.2% |
| S | 24225 | 6.1% |
| T | 23328 | 5.9% |
| B | 23205 | 5.9% |
| P | 19958 | 5.0% |
| L | 19002 | 4.8% |
| D | 17854 | 4.5% |
| M | 17305 | 4.4% |
| Other values (16) | 159531 |
Common
| Value | Count | Frequency (%) |
| 0 | 125986 | |
| 1 | 79593 | |
| 2 | 65577 | |
| 3 | 50016 | 8.6% |
| 4 | 43995 | 7.6% |
| 5 | 41613 | 7.2% |
| - | 36726 | 6.3% |
| 6 | 36188 | 6.3% |
| 7 | 30859 | 5.3% |
| 8 | 29412 | 5.1% |
| Other values (6) | 38786 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 974319 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 125986 | 12.9% |
| 1 | 79593 | 8.2% |
| 2 | 65577 | 6.7% |
| 3 | 50016 | 5.1% |
| 4 | 43995 | 4.5% |
| 5 | 41613 | 4.3% |
| A | 36755 | 3.8% |
| - | 36726 | 3.8% |
| 6 | 36188 | 3.7% |
| 7 | 30859 | 3.2% |
| Other values (32) | 427011 |
ARTDSC
Text
| Distinct | 26068 |
|---|---|
| Distinct (%) | 24.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 30 |
| Mean length | 27.219916 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2940132 |
|---|---|
| Distinct characters | 80 |
| Distinct categories | 13 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 10742 ? |
|---|---|
| Unique (%) | 9.9% |
Sample
| 1st row | FI-65F |
|---|---|
| 2nd row | SRFC GO TYPE COVER BLACK |
| 3rd row | 126A MAGENTA LASERJET PRINT CARTR. |
| 4th row | CAVO DP/DP LSOH M/M MT10 |
| 5th row | HELIOS IP VERSO - UNIT BASE CON CA |
| Value | Count | Frequency (%) |
| hp | 6055 | 1.2% |
| toner | 5003 | 1.0% |
| 4760 | 0.9% | |
| nero | 4500 | 0.9% |
| black | 4127 | 0.8% |
| pro | 3508 | 0.7% |
| usb | 2775 | 0.5% |
| monitor | 2755 | 0.5% |
| g9 | 2681 | 0.5% |
| dell | 2574 | 0.5% |
| Other values (22701) | 470037 |
Most occurring characters
| Value | Count | Frequency (%) |
| 411587 | 14.0% | |
| A | 162467 | 5.5% |
| E | 159987 | 5.4% |
| T | 136490 | 4.6% |
| O | 136156 | 4.6% |
| I | 135016 | 4.6% |
| R | 133301 | 4.5% |
| S | 118224 | 4.0% |
| C | 111914 | 3.8% |
| L | 102656 | 3.5% |
| Other values (70) | 1332334 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1952050 | |
| Decimal Number | 482799 | 16.4% |
| Space Separator | 411587 | 14.0% |
| Other Punctuation | 41972 | 1.4% |
| Dash Punctuation | 30727 | 1.0% |
| Math Symbol | 9554 | 0.3% |
| Lowercase Letter | 4826 | 0.2% |
| Open Punctuation | 2030 | 0.1% |
| Close Punctuation | 1795 | 0.1% |
| Connector Punctuation | 1492 | 0.1% |
| Other values (3) | 1300 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 162467 | 8.3% |
| E | 159987 | 8.2% |
| T | 136490 | 7.0% |
| O | 136156 | 7.0% |
| I | 135016 | 6.9% |
| R | 133301 | 6.8% |
| S | 118224 | 6.1% |
| C | 111914 | 5.7% |
| L | 102656 | 5.3% |
| N | 100912 | 5.2% |
| Other values (18) | 654927 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 22234 | |
| . | 17503 | |
| : | 756 | 1.8% |
| , | 714 | 1.7% |
| " | 238 | 0.6% |
| ! | 230 | 0.5% |
| ' | 200 | 0.5% |
| * | 44 | 0.1% |
| & | 41 | 0.1% |
| ? | 10 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 95953 | |
| 1 | 82266 | |
| 2 | 77927 | |
| 5 | 54176 | |
| 3 | 43866 | |
| 4 | 38805 | |
| 6 | 30843 | 6.4% |
| 8 | 23184 | 4.8% |
| 7 | 20686 | 4.3% |
| 9 | 15093 | 3.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 1270 | |
| t | 1016 | |
| o | 762 | |
| z | 508 | 10.5% |
| r | 254 | 5.3% |
| u | 254 | 5.3% |
| a | 254 | 5.3% |
| n | 254 | 5.3% |
| f | 254 | 5.3% |
Control
| Value | Count | Frequency (%) |
| € | 237 | |
| ™ | 33 | 10.9% |
| ‰ | 19 | 6.3% |
| ˆ | 6 | 2.0% |
| œ | 5 | 1.7% |
| – | 3 | 1.0% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 4780 | |
| > | 3176 | |
| = | 1591 | 16.7% |
| < | 7 | 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2027 | |
| [ | 3 | 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1792 | |
| ] | 3 | 0.2% |
Currency Symbol
| Value | Count | Frequency (%) |
| £ | 757 | |
| $ | 32 | 4.1% |
Other Symbol
| Value | Count | Frequency (%) |
| ° | 202 | |
| ® | 6 | 2.9% |
Space Separator
| Value | Count | Frequency (%) |
| 411587 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 30727 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1492 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1956876 | |
| Common | 983256 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 411587 | ||
| 0 | 95953 | 9.8% |
| 1 | 82266 | 8.4% |
| 2 | 77927 | 7.9% |
| 5 | 54176 | 5.5% |
| 3 | 43866 | 4.5% |
| 4 | 38805 | 3.9% |
| 6 | 30843 | 3.1% |
| - | 30727 | 3.1% |
| 8 | 23184 | 2.4% |
| Other values (33) | 93922 | 9.6% |
Latin
| Value | Count | Frequency (%) |
| A | 162467 | 8.3% |
| E | 159987 | 8.2% |
| T | 136490 | 7.0% |
| O | 136156 | 7.0% |
| I | 135016 | 6.9% |
| R | 133301 | 6.8% |
| S | 118224 | 6.0% |
| C | 111914 | 5.7% |
| L | 102656 | 5.2% |
| N | 100912 | 5.2% |
| Other values (27) | 659753 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2937596 | |
| None | 2536 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 411587 | 14.0% | |
| A | 162467 | 5.5% |
| E | 159987 | 5.4% |
| T | 136490 | 4.6% |
| O | 136156 | 4.6% |
| I | 135016 | 4.6% |
| R | 133301 | 4.5% |
| S | 118224 | 4.0% |
| C | 111914 | 3.8% |
| L | 102656 | 3.5% |
| Other values (59) | 1329798 |
None
| Value | Count | Frequency (%) |
| Â | 965 | |
| £ | 757 | |
| Ã | 303 | 11.9% |
| € | 237 | 9.3% |
| ° | 202 | 8.0% |
| ™ | 33 | 1.3% |
| ‰ | 19 | 0.7% |
| ˆ | 6 | 0.2% |
| ® | 6 | 0.2% |
| œ | 5 | 0.2% |
BRANDID
Text
| Distinct | 676 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.958922 |
| Min length | 2 |
Characters and Unicode
| Total characters | 319605 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 52 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | FUJ |
|---|---|
| 2nd row | SUA |
| 3rd row | YHP |
| 4th row | NEO |
| 5th row | 2NN |
| Value | Count | Frequency (%) |
| de1 | 6039 | 5.6% |
| hp | 4437 | 4.1% |
| yhp | 4085 | 3.8% |
| yep | 2124 | 2.0% |
| dee | 2094 | 1.9% |
| neo | 1857 | 1.7% |
| wpe | 1780 | 1.6% |
| len | 1777 | 1.6% |
| hpe | 1751 | 1.6% |
| cel | 1212 | 1.1% |
| Other values (666) | 80858 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 31749 | 9.9% |
| P | 28877 | 9.0% |
| H | 21409 | 6.7% |
| S | 20786 | 6.5% |
| A | 19117 | 6.0% |
| 5 | 18049 | 5.6% |
| Y | 17513 | 5.5% |
| N | 15691 | 4.9% |
| L | 14812 | 4.6% |
| D | 13839 | 4.3% |
| Other values (24) | 117763 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 288621 | |
| Decimal Number | 30984 | 9.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 31749 | 11.0% |
| P | 28877 | 10.0% |
| H | 21409 | 7.4% |
| S | 20786 | 7.2% |
| A | 19117 | 6.6% |
| Y | 17513 | 6.1% |
| N | 15691 | 5.4% |
| L | 14812 | 5.1% |
| D | 13839 | 4.8% |
| C | 12681 | 4.4% |
| Other values (16) | 92147 |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 18049 | |
| 1 | 7912 | |
| 2 | 4094 | 13.2% |
| 9 | 378 | 1.2% |
| 7 | 218 | 0.7% |
| 3 | 180 | 0.6% |
| 8 | 148 | 0.5% |
| 0 | 5 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 288621 | |
| Common | 30984 | 9.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 31749 | 11.0% |
| P | 28877 | 10.0% |
| H | 21409 | 7.4% |
| S | 20786 | 7.2% |
| A | 19117 | 6.6% |
| Y | 17513 | 6.1% |
| N | 15691 | 5.4% |
| L | 14812 | 5.1% |
| D | 13839 | 4.8% |
| C | 12681 | 4.4% |
| Other values (16) | 92147 |
Common
| Value | Count | Frequency (%) |
| 5 | 18049 | |
| 1 | 7912 | |
| 2 | 4094 | 13.2% |
| 9 | 378 | 1.2% |
| 7 | 218 | 0.7% |
| 3 | 180 | 0.6% |
| 8 | 148 | 0.5% |
| 0 | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 319605 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 31749 | 9.9% |
| P | 28877 | 9.0% |
| H | 21409 | 6.7% |
| S | 20786 | 6.5% |
| A | 19117 | 6.0% |
| 5 | 18049 | 5.6% |
| Y | 17513 | 5.5% |
| N | 15691 | 4.9% |
| L | 14812 | 4.6% |
| D | 13839 | 4.3% |
| Other values (24) | 117763 |
CATEGORYID
Text
| Distinct | 378 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 2 |
| Mean length | 2.0095913 |
| Min length | 2 |
Characters and Unicode
| Total characters | 217064 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 31 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SH |
|---|---|
| 2nd row | AM |
| 3rd row | MC |
| 4th row | EG |
| 5th row | WV |
| Value | Count | Frequency (%) |
| mc | 12889 | 11.9% |
| no | 5815 | 5.4% |
| mo | 5170 | 4.8% |
| 1e | 3958 | 3.7% |
| vf | 3042 | 2.8% |
| 1n | 3003 | 2.8% |
| pc | 2872 | 2.7% |
| es | 2821 | 2.6% |
| tm | 2500 | 2.3% |
| qf | 2150 | 2.0% |
| Other values (368) | 63794 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 29054 | |
| C | 22695 | 10.5% |
| N | 17802 | 8.2% |
| 1 | 17264 | 8.0% |
| O | 13817 | 6.4% |
| E | 12212 | 5.6% |
| T | 8860 | 4.1% |
| H | 8647 | 4.0% |
| P | 7667 | 3.5% |
| S | 7056 | 3.3% |
| Other values (35) | 71990 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 186383 | |
| Decimal Number | 29117 | 13.4% |
| Lowercase Letter | 1016 | 0.5% |
| Close Punctuation | 254 | 0.1% |
| Open Punctuation | 254 | 0.1% |
| Currency Symbol | 32 | < 0.1% |
| Connector Punctuation | 8 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 29054 | |
| C | 22695 | |
| N | 17802 | 9.6% |
| O | 13817 | 7.4% |
| E | 12212 | 6.6% |
| T | 8860 | 4.8% |
| H | 8647 | 4.6% |
| P | 7667 | 4.1% |
| S | 7056 | 3.8% |
| F | 6889 | 3.7% |
| Other values (17) | 51684 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 17264 | |
| 0 | 4701 | 16.1% |
| 3 | 2626 | 9.0% |
| 2 | 1088 | 3.7% |
| 4 | 1079 | 3.7% |
| 6 | 989 | 3.4% |
| 9 | 670 | 2.3% |
| 5 | 323 | 1.1% |
| 7 | 216 | 0.7% |
| 8 | 161 | 0.6% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 508 | |
| u | 254 | |
| n | 254 |
Currency Symbol
| Value | Count | Frequency (%) |
| £ | 20 | |
| $ | 12 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 254 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 254 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 187399 | |
| Common | 29665 | 13.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 29054 | |
| C | 22695 | |
| N | 17802 | 9.5% |
| O | 13817 | 7.4% |
| E | 12212 | 6.5% |
| T | 8860 | 4.7% |
| H | 8647 | 4.6% |
| P | 7667 | 4.1% |
| S | 7056 | 3.8% |
| F | 6889 | 3.7% |
| Other values (20) | 52700 |
Common
| Value | Count | Frequency (%) |
| 1 | 17264 | |
| 0 | 4701 | 15.8% |
| 3 | 2626 | 8.9% |
| 2 | 1088 | 3.7% |
| 4 | 1079 | 3.6% |
| 6 | 989 | 3.3% |
| 9 | 670 | 2.3% |
| 5 | 323 | 1.1% |
| ) | 254 | 0.9% |
| ( | 254 | 0.9% |
| Other values (5) | 417 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 217024 | |
| None | 40 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 29054 | |
| C | 22695 | 10.5% |
| N | 17802 | 8.2% |
| 1 | 17264 | 8.0% |
| O | 13817 | 6.4% |
| E | 12212 | 5.6% |
| T | 8860 | 4.1% |
| H | 8647 | 4.0% |
| P | 7667 | 3.5% |
| S | 7056 | 3.3% |
| Other values (33) | 71950 |
None
| Value | Count | Frequency (%) |
| Â | 20 | |
| £ | 20 |
CATEGORYDSC
Text
| Distinct | 383 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
Length
| Max length | 53 |
|---|---|
| Median length | 37 |
| Mean length | 16.403327 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1771789 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 31 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SCANNER |
|---|---|
| 2nd row | ACCESSORI TABLET E EBOOK READER |
| 3rd row | MATERIALE DI CONSUMO |
| 4th row | CAVI AUDIO-VIDEO |
| 5th row | VIDEOCITOFONI IP |
| Value | Count | Frequency (%) |
| e | 24320 | 9.6% |
| di | 15121 | 6.0% |
| materiale | 12889 | 5.1% |
| consumo | 12889 | 5.1% |
| desktop | 8042 | 3.2% |
| notebook | 6893 | 2.7% |
| accessori | 6568 | 2.6% |
| monitor | 5988 | 2.4% |
| software | 5184 | 2.0% |
| 4589 | 1.8% | |
| Other values (493) | 150573 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 193378 | |
| I | 177655 | |
| O | 163940 | 9.3% |
| 145042 | 8.2% | |
| T | 139088 | 7.9% |
| A | 133569 | 7.5% |
| R | 120116 | 6.8% |
| S | 97967 | 5.5% |
| C | 93237 | 5.3% |
| N | 85056 | 4.8% |
| Other values (32) | 422741 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1608624 | |
| Space Separator | 145042 | 8.2% |
| Dash Punctuation | 6643 | 0.4% |
| Other Punctuation | 3355 | 0.2% |
| Close Punctuation | 3305 | 0.2% |
| Open Punctuation | 3305 | 0.2% |
| Lowercase Letter | 1016 | 0.1% |
| Control | 438 | < 0.1% |
| Decimal Number | 61 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 193378 | |
| I | 177655 | |
| O | 163940 | |
| T | 139088 | |
| A | 133569 | 8.3% |
| R | 120116 | 7.5% |
| S | 97967 | 6.1% |
| C | 93237 | 5.8% |
| N | 85056 | 5.3% |
| L | 63302 | 3.9% |
| Other values (17) | 341316 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2930 | |
| . | 271 | 8.1% |
| ' | 60 | 1.8% |
| & | 58 | 1.7% |
| , | 36 | 1.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 508 | |
| u | 254 | |
| n | 254 |
Control
| Value | Count | Frequency (%) |
| € | 426 | |
| ˆ | 12 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 145042 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6643 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3305 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3305 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 61 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1609640 | |
| Common | 162149 | 9.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 193378 | |
| I | 177655 | |
| O | 163940 | |
| T | 139088 | |
| A | 133569 | 8.3% |
| R | 120116 | 7.5% |
| S | 97967 | 6.1% |
| C | 93237 | 5.8% |
| N | 85056 | 5.3% |
| L | 63302 | 3.9% |
| Other values (20) | 342332 |
Common
| Value | Count | Frequency (%) |
| 145042 | ||
| - | 6643 | 4.1% |
| ) | 3305 | 2.0% |
| ( | 3305 | 2.0% |
| / | 2930 | 1.8% |
| € | 426 | 0.3% |
| . | 271 | 0.2% |
| 3 | 61 | < 0.1% |
| ' | 60 | < 0.1% |
| & | 58 | < 0.1% |
| Other values (2) | 48 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1770913 | |
| None | 876 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 193378 | |
| I | 177655 | |
| O | 163940 | 9.3% |
| 145042 | 8.2% | |
| T | 139088 | 7.9% |
| A | 133569 | 7.5% |
| R | 120116 | 6.8% |
| S | 97967 | 5.5% |
| C | 93237 | 5.3% |
| N | 85056 | 4.8% |
| Other values (29) | 421865 |
None
| Value | Count | Frequency (%) |
| Ã | 438 | |
| € | 426 | |
| ˆ | 12 | 1.4% |
BRANDDSC
Text
| Distinct | 675 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 844.0 KiB |
Length
| Max length | 35 |
|---|---|
| Median length | 29 |
| Mean length | 10.954247 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1183212 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 52 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | FUJITSU |
|---|---|
| 2nd row | MICROSOFT SURFACE COMMERCIAL |
| 3rd row | CONSUMABILI HP |
| 4th row | NILOX PC COMPONENTS |
| 5th row | 2N |
| Value | Count | Frequency (%) |
| consumabili | 10953 | 6.2% |
| hp | 10358 | 5.9% |
| dell | 8134 | 4.6% |
| inc | 4437 | 2.5% |
| server | 4326 | 2.4% |
| networking | 3418 | 1.9% |
| hpe | 3237 | 1.8% |
| epson | 3114 | 1.8% |
| samsung | 2935 | 1.7% |
| lenovo | 2763 | 1.6% |
| Other values (755) | 123105 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 117588 | 9.9% |
| O | 103077 | 8.7% |
| I | 92594 | 7.8% |
| N | 85503 | 7.2% |
| S | 72484 | 6.1% |
| A | 72161 | 6.1% |
| L | 72089 | 6.1% |
| R | 70283 | 5.9% |
| 68766 | 5.8% | |
| T | 67119 | 5.7% |
| Other values (30) | 361548 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1105738 | |
| Space Separator | 68766 | 5.8% |
| Other Punctuation | 4019 | 0.3% |
| Dash Punctuation | 3167 | 0.3% |
| Decimal Number | 1522 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 117588 | |
| O | 103077 | 9.3% |
| I | 92594 | 8.4% |
| N | 85503 | 7.7% |
| S | 72484 | 6.6% |
| A | 72161 | 6.5% |
| L | 72089 | 6.5% |
| R | 70283 | 6.4% |
| T | 67119 | 6.1% |
| C | 61726 | 5.6% |
| Other values (16) | 291114 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1226 | |
| 3 | 181 | 11.9% |
| 1 | 34 | 2.2% |
| 9 | 34 | 2.2% |
| 8 | 34 | 2.2% |
| 0 | 6 | 0.4% |
| 7 | 5 | 0.3% |
| 4 | 2 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3207 | |
| & | 671 | 16.7% |
| / | 128 | 3.2% |
| ' | 13 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 68766 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3167 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1105738 | |
| Common | 77474 | 6.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 117588 | |
| O | 103077 | 9.3% |
| I | 92594 | 8.4% |
| N | 85503 | 7.7% |
| S | 72484 | 6.6% |
| A | 72161 | 6.5% |
| L | 72089 | 6.5% |
| R | 70283 | 6.4% |
| T | 67119 | 6.1% |
| C | 61726 | 5.6% |
| Other values (16) | 291114 |
Common
| Value | Count | Frequency (%) |
| 68766 | ||
| . | 3207 | 4.1% |
| - | 3167 | 4.1% |
| 2 | 1226 | 1.6% |
| & | 671 | 0.9% |
| 3 | 181 | 0.2% |
| / | 128 | 0.2% |
| 1 | 34 | < 0.1% |
| 9 | 34 | < 0.1% |
| 8 | 34 | < 0.1% |
| Other values (4) | 26 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1183212 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 117588 | 9.9% |
| O | 103077 | 8.7% |
| I | 92594 | 7.8% |
| N | 85503 | 7.2% |
| S | 72484 | 6.1% |
| A | 72161 | 6.1% |
| L | 72089 | 6.1% |
| R | 70283 | 5.9% |
| 68766 | 5.8% | |
| T | 67119 | 5.7% |
| Other values (30) | 361548 |
| Unnamed: 0 | DEALKEY | DEALDETKEY | DEALVALUE | DEALQTY | ORDER_PRICE | ORIGINAL_PRICE | ORIGINAL_PRICE_NO_DISCOUNT_PERS | CUSTOMER_DISCOUNT_PERS | DISCOUNT_PCT | CHANNELID | CHANNELDSC | HAS_REAL_ORDER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Unnamed: 0 | 1.000 | 0.002 | 0.002 | -0.004 | 0.001 | -0.005 | -0.005 | -0.005 | -0.001 | 0.005 | 0.004 | 0.004 | 0.000 |
| DEALKEY | 0.002 | 1.000 | 1.000 | -0.050 | 0.023 | -0.059 | -0.059 | -0.062 | -0.150 | 0.035 | 0.057 | 0.049 | 0.045 |
| DEALDETKEY | 0.002 | 1.000 | 1.000 | -0.051 | 0.022 | -0.060 | -0.060 | -0.062 | -0.150 | 0.035 | 0.057 | 0.049 | 0.049 |
| DEALVALUE | -0.004 | -0.050 | -0.051 | 1.000 | 0.279 | 0.809 | 0.808 | 0.808 | -0.253 | -0.297 | 0.000 | 0.000 | 0.000 |
| DEALQTY | 0.001 | 0.023 | 0.022 | 0.279 | 1.000 | -0.270 | -0.270 | -0.271 | 0.040 | -0.066 | 0.023 | 0.023 | 0.021 |
| ORDER_PRICE | -0.005 | -0.059 | -0.060 | 0.809 | -0.270 | 1.000 | 1.000 | 1.000 | -0.273 | -0.251 | 0.000 | 0.000 | 0.008 |
| ORIGINAL_PRICE | -0.005 | -0.059 | -0.060 | 0.808 | -0.270 | 1.000 | 1.000 | 1.000 | -0.275 | -0.241 | 0.000 | 0.000 | 0.008 |
| ORIGINAL_PRICE_NO_DISCOUNT_PERS | -0.005 | -0.062 | -0.062 | 0.808 | -0.271 | 1.000 | 1.000 | 1.000 | -0.260 | -0.241 | 0.000 | 0.000 | 0.008 |
| CUSTOMER_DISCOUNT_PERS | -0.001 | -0.150 | -0.150 | -0.253 | 0.040 | -0.273 | -0.275 | -0.260 | 1.000 | 0.021 | 0.144 | 0.144 | 0.139 |
| DISCOUNT_PCT | 0.005 | 0.035 | 0.035 | -0.297 | -0.066 | -0.251 | -0.241 | -0.241 | 0.021 | 1.000 | 0.101 | 0.102 | 0.207 |
| CHANNELID | 0.004 | 0.057 | 0.057 | 0.000 | 0.023 | 0.000 | 0.000 | 0.000 | 0.144 | 0.101 | 1.000 | 1.000 | 0.199 |
| CHANNELDSC | 0.004 | 0.049 | 0.049 | 0.000 | 0.023 | 0.000 | 0.000 | 0.000 | 0.144 | 0.102 | 1.000 | 1.000 | 0.200 |
| HAS_REAL_ORDER | 0.000 | 0.045 | 0.049 | 0.000 | 0.021 | 0.008 | 0.008 | 0.008 | 0.139 | 0.207 | 0.199 | 0.200 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Unnamed: 0 | DEALKEY | DEALDETKEY | CUSTOMERID | CHANNELID | CHANNELDSC | HAS_REAL_ORDER | DEALVALUE | DEALQTY | ORDER_PRICE | ORIGINAL_PRICE | ORIGINAL_PRICE_NO_DISCOUNT_PERS | QUOTATION_DATE | CUSTOMER_DISCOUNT_PERS | DISCOUNT_PCT | ARTID_DATE_CREATE | ARTID | ARTDSC | BRANDID | CATEGORYID | CATEGORYDSC | BRANDDSC | CUSTOMER_CREATE_DATE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 3682848.0 | 12089692.0 | 053e113f9b | SM | SALES UNIT MEDIUM BUSINESS | 1 | 251.477800 | 1.0 | 251.477800 | 256.61 | 257.89305 | 2023-05-09 | 0.5 | 2.00 | 2013-08-28 | FI-65F | FI-65F | FUJ | SH | SCANNER | FUJITSU | 2011-02-01 |
| 1 | 1 | 3644306.0 | 11997831.0 | b6fc01a771 | CS | OFFICE PRODUCTS SALES AREA | 1 | 67.257400 | 1.0 | 67.257400 | 68.63 | 68.63000 | 2023-03-08 | 0.0 | 2.00 | 2020-05-13 | KCN-00032 | SRFC GO TYPE COVER BLACK | SUA | AM | ACCESSORI TABLET E EBOOK READER | MICROSOFT SURFACE COMMERCIAL | 2006-01-01 |
| 2 | 2 | 3683424.0 | 12091190.0 | 9b2a287a25 | SM | SALES UNIT MEDIUM BUSINESS | 1 | 51.887917 | 1.0 | 51.887917 | 52.63 | 52.63000 | 2023-05-09 | 0.0 | 1.41 | 2010-10-25 | CE313A | 126A MAGENTA LASERJET PRINT CARTR. | YHP | MC | MATERIALE DI CONSUMO | CONSUMABILI HP | 2006-01-01 |
| 3 | 3 | 3656576.0 | 12027561.0 | 64354f1917 | CS | OFFICE PRODUCTS SALES AREA | 1 | 20.148800 | 1.0 | 20.148800 | 20.56 | 20.56000 | 2023-03-25 | 0.0 | 2.00 | 2015-12-17 | NX090202106 | CAVO DP/DP LSOH M/M MT10 | NEO | EG | CAVI AUDIO-VIDEO | NILOX PC COMPONENTS | 2006-01-01 |
| 4 | 4 | 3679663.0 | 12081975.0 | df63f09ef0 | SM | SALES UNIT MEDIUM BUSINESS | 1 | 726.474000 | 1.0 | 726.474000 | 741.30 | 741.30000 | 2023-05-03 | 0.0 | 2.00 | 2017-05-15 | 9155101C | HELIOS IP VERSO - UNIT BASE CON CA | 2NN | WV | VIDEOCITOFONI IP | 2N | 2006-01-01 |
| 5 | 5 | 3724017.0 | 12188409.0 | 21e1cd63f1 | SM | SALES UNIT MEDIUM BUSINESS | 0 | 5450.000000 | 2.0 | 2725.000000 | 2725.00 | 2725.00000 | 2023-07-12 | 0.0 | 0.00 | 2022-11-28 | M7010W18ARIN | =>>CELSIUS M7010 | FJT | PB | WORKSTATION | FUJITSU TECHNOLOGY SOLUTIONS GMBH | 2006-01-01 |
| 6 | 6 | 3650885.0 | 12013150.0 | 7c656eaffe | SM | SALES UNIT MEDIUM BUSINESS | 1 | 14.606600 | 1.0 | 14.606600 | 14.68 | 14.90020 | 2023-03-16 | 1.5 | 0.50 | 2020-12-10 | 4XD0K25030 | ESSENTIAL STEREO ANALOG HEADSET | LEN | HR | CUFFIE E AURICOLARI | LENOVO | 2017-02-07 |
| 7 | 7 | 3709768.0 | 12154652.0 | ef82ad5100 | SM | SALES UNIT MEDIUM BUSINESS | 0 | 3734.000000 | 1.0 | 3734.000000 | 3734.00 | 3734.00000 | 2023-06-20 | 0.0 | 0.00 | 2020-12-29 | RS3621XSP | RS3621XS+ | SNL | NN | NAS | SYNOLOGY | 2006-01-01 |
| 8 | 8 | 3688728.0 | 12103661.0 | 438f7f62ea | CS | OFFICE PRODUCTS SALES AREA | 0 | 290.050000 | 5.0 | 58.010000 | 58.01 | 58.01000 | 2023-05-17 | 0.0 | 0.00 | 2023-03-27 | NXM19FHD01 | MONITOR 18 5 TN 5MS VGA + HDMI 75HZ | NHW | MO | MONITOR DESKTOP | NILOX MONITOR | 2006-01-01 |
| 9 | 9 | 3725673.0 | 12192333.0 | 71d26c468a | CC | CONTACT CENTER | 0 | 9.624592 | 1.0 | 9.624592 | 9.91 | 9.91000 | 2023-07-16 | 0.0 | 2.88 | 2014-03-06 | 18679 | TRINO HD VIDEO WEBCAM | TRS | WE | WEB-CAM | TRUST | 2006-01-01 |
| Unnamed: 0 | DEALKEY | DEALDETKEY | CUSTOMERID | CHANNELID | CHANNELDSC | HAS_REAL_ORDER | DEALVALUE | DEALQTY | ORDER_PRICE | ORIGINAL_PRICE | ORIGINAL_PRICE_NO_DISCOUNT_PERS | QUOTATION_DATE | CUSTOMER_DISCOUNT_PERS | DISCOUNT_PCT | ARTID_DATE_CREATE | ARTID | ARTDSC | BRANDID | CATEGORYID | CATEGORYDSC | BRANDDSC | CUSTOMER_CREATE_DATE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108004 | 108004 | 3738901.0 | 12225963.0 | 33d8399d6a | SM | SALES UNIT MEDIUM BUSINESS | 1 | 369.000000 | 1.0 | 369.000000 | 369.00 | 369.0000 | 2023-08-09 | 0.0 | 0.00 | 2015-05-21 | JG960A | HP 1950-24G-2SFP+-2XGT SWITCH | HPN | NS | SWITCH | HPE NETWORKING | 2006-01-01 |
| 108005 | 108005 | 3642774.0 | 11993881.0 | aa04da4a87 | FU | FURNITURE (FURNITURE CHANNEL D | 1 | 395.764512 | 1.0 | 395.764512 | 399.52 | 415.5008 | 2023-03-06 | 4.0 | 0.94 | 2020-08-04 | F2WV5S8S0E | LAV SLIM F2WV5S8S0E 8KG C TURBSTEAM | LGS | 03 | LAVATRICI | LG ELETTRODOMESTICI | 2015-03-19 |
| 108006 | 108006 | 3701607.0 | 12133739.0 | e95c2227cc | CS | OFFICE PRODUCTS SALES AREA | 1 | 313.595880 | 2.0 | 156.797940 | 159.90 | 159.9000 | 2023-06-07 | 0.0 | 1.94 | 2022-02-12 | 27M1N3200VA | 27 MOMENTUM GAMING MONITOR VA | PHI | MO | MONITOR DESKTOP | PHILIPS | 2006-01-01 |
| 108007 | 108007 | 3727030.0 | 12195872.0 | e3b4be0e50 | CC | CONTACT CENTER | 0 | 4576.420000 | 1.0 | 4576.420000 | 4576.42 | 4576.4200 | 2023-07-18 | 0.0 | 0.00 | 2021-10-08 | WGM29002103 | TRADE UP M290 CON 3 ANNI TOTAL | WTG | NF | FIREWALL E UTM | WATCHGUARD | 2018-01-29 |
| 108008 | 108008 | 3652172.0 | 12016467.0 | 438f7f62ea | CS | OFFICE PRODUCTS SALES AREA | 1 | 264.143100 | 3.0 | 88.047700 | 89.00 | 89.0000 | 2023-03-20 | 0.0 | 1.07 | 2022-03-03 | NXM27FHD02 | MONITOR 27 FHD HDMI VGA BASIC | NHW | MO | MONITOR DESKTOP | NILOX MONITOR | 2006-01-01 |
| 108009 | 108009 | 3708545.0 | 12151294.0 | 1972a513cf | GD | GDO / GDS | 0 | 13439.000000 | 10.0 | 1343.900000 | 1343.90 | 1343.9000 | 2023-06-19 | 0.0 | 0.00 | 2023-04-27 | 5F150EA | Z2 MINI G9 I7 UMA 32/1TB W11P | HP | PB | WORKSTATION | HP INC | 2018-04-04 |
| 108010 | 108010 | 3714399.0 | 12166039.0 | 1cdae8071d | CS | OFFICE PRODUCTS SALES AREA | 1 | 12.147300 | 1.0 | 12.147300 | 12.27 | 12.2700 | 2023-06-27 | 0.0 | 1.00 | 2021-04-06 | MPWE5MBI | CF6 CHALK MARKER MEDIO BIANCO | 5OS | 1E | SCRITTURA E CORREZIONE | OSAMA | 2013-02-06 |
| 108011 | 108011 | 3658185.0 | 12031622.0 | eca5263750 | CS | OFFICE PRODUCTS SALES AREA | 1 | 45.183590 | 2.0 | 22.591795 | 22.85 | 22.8500 | 2023-03-28 | 0.0 | 1.13 | 2011-06-20 | PR1438R | TIMBRO ROSSO 14X38MM (CONF.6PZ) | 5BH | 1Z | TIMBRI | BROTHER | 2016-06-17 |
| 108012 | 108012 | 3660095.0 | 12036046.0 | d1730100aa | CS | OFFICE PRODUCTS SALES AREA | 0 | 99.000000 | 50.0 | 1.980000 | 1.98 | 1.9800 | 2023-03-30 | 0.0 | 0.00 | 2019-06-12 | LKMOS04 | MINI MOUSE OTTICO USB 3 TASTI | NEO | TM | TASTIERE E MOUSE | NILOX PC COMPONENTS | 2017-11-20 |
| 108013 | 108013 | 3647608.0 | 12005566.0 | 024d00a380 | SM | SALES UNIT MEDIUM BUSINESS | 1 | 712.471400 | 2.0 | 356.235700 | 359.00 | 359.0000 | 2023-03-13 | 0.0 | 0.77 | 2022-03-09 | E1600WKAT-BD10M | E1600WKAT/15 6 /N4500/256/4/END | ASD | IO | PC ALL IN ONE | ASUS DESKTOP | 2006-01-01 |